When does it become useful?

Solution Architects are generally involved very early in a project lifecycle. Their involvement is typically a prerequisite for technology projects of any non trivial nature.